﻿
-- Ajout d'une colonne avec les noms courts des équipes (pour les smartphones)
------------------------------------------------------------------------------

-- Store if it's the best score of the day for each event
ALTER TABLE [ParieurProDB].[dbo].[Teams]
ADD [ShortName] nchar(20) NULL;
GO

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.ShortName='Ajaccio'
where [ParieurProDB].dbo.Teams.Name='AC Ajaccio';
GO

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.ShortName='Toulouse'
where [ParieurProDB].dbo.Teams.Name='Toulouse FC';
GO

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.ShortName='Nancy'
where [ParieurProDB].dbo.Teams.Name='AS Nancy Lorraine';
GO

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.ShortName='Lille'
where [ParieurProDB].dbo.Teams.Name='LOSC Lille Métropole';
GO

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.ShortName='Bordeaux'
where [ParieurProDB].dbo.Teams.Name='Girondins de Bordeaux';
GO

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.ShortName='St-Etienne'
where [ParieurProDB].dbo.Teams.Name='AS Saint-Etienne';
GO

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.ShortName='Brest'
where [ParieurProDB].dbo.Teams.Name='Stade Brestois 29';
GO

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.ShortName='Evian'
where [ParieurProDB].dbo.Teams.Name='Evian TG FC';
GO

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.ShortName='Caen'
where [ParieurProDB].dbo.Teams.Name='SM Caen';
GO

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.ShortName='Valenciennes'
where [ParieurProDB].dbo.Teams.Name='Valenciennes FC';
GO

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.ShortName='Dijon'
where [ParieurProDB].dbo.Teams.Name='Dijon FCO';
GO

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.ShortName='Rennes'
where [ParieurProDB].dbo.Teams.Name='Stade Rennais FC';
GO

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.ShortName='Marseille'
where [ParieurProDB].dbo.Teams.Name='Olympique de Marseille';
GO

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.ShortName='Sochaux'
where [ParieurProDB].dbo.Teams.Name='FC Sochaux Montbeliard';
GO

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.ShortName='Montpellier'
where [ParieurProDB].dbo.Teams.Name='Montpellier Hérault SC';
GO

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.ShortName='Auxerre'
where [ParieurProDB].dbo.Teams.Name='AJ Auxerre';
GO

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.ShortName='Nice'
where [ParieurProDB].dbo.Teams.Name='OGC Nice';
GO

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.ShortName='Lyon'
where [ParieurProDB].dbo.Teams.Name='Olympique Lyonnais';
GO

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.ShortName='PSG'
where [ParieurProDB].dbo.Teams.Name='Paris Saint-Germain';
GO

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.ShortName='Lorient'
where [ParieurProDB].dbo.Teams.Name='FC Lorient';
GO